create procedure [dbo].[BAEEventSetupMoveQuestionUp] @id int,
     @eventCode varchar(15) as
DECLARE @questionorder AS int;

    SELECT @questionorder =  QuestionOrder FROM EventSetupQuestion WHERE EventSetupQuestionID = @id;

    if(@questionorder > 1)
    BEGIN
        /* Move Question Down */
        UPDATE EventSetupQuestion
        SET QuestionOrder = QuestionOrder + 1
        WHERE EventCode = @eventCode AND QuestionOrder = @questionorder - 1;
        /* Move Question Up */
        UPDATE EventSetupQuestion
        SET QuestionOrder = QuestionOrder - 1
        WHERE EventSetupQuestionID = @id;
    END

GO